Tabela Service

Definicja tabeli Service

Name

Service

Code

Service

Comment

PL: Dane slownika uslug
EN: Service dictionary data
DE: Die Tabelle fur der Dienste


Lista kolumn tabeli Service

Name

Code

ServID

ServID

ICDID

ICDID

VatRateID

VatRateID

PerfTemplateID

PerfTemplateID

UnitID

UnitID

ServiceTypeID

ServiceTypeID

ServiceComponentID

ServiceComponentID

SysFctID

SysFctID

DepartmentID

DepartmentID

InterfaceCd

InterfaceCd

Code

Code

Description

Description

StartDT

StartDT

StopDT

StopDT

Independent

Independent

Comments

Comments

IsExternal

IsExternal

Active

Active

Mnemonic

Mnemonic

Recursive

Recursive

Duration

Duration

IsProfile

IsProfile

AccountServID

AccountServID

IsAccounting

IsAccounting

NotMedical

NotMedical

OPK

OPK

PKWiU

PKWiU

ShortName

ShortName

FullName

FullName

OPK2

OPK2

NotForPatient

NotForPatient

ReferralMandatory

ReferralMandatory

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

IsPackage

IsPackage


Kolumna ServID tabeli Service

Definicja kolumny ServID tabeli Service

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID uslugi


Kolumna ICDID tabeli Service

Definicja kolumny ICDID tabeli Service

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VatRateID tabeli Service

Definicja kolumny VatRateID tabeli Service

Name

VatRateID

Code

VatRateID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID stawki VAT


Kolumna PerfTemplateID tabeli Service

Definicja kolumny PerfTemplateID tabeli Service

Name

PerfTemplateID

Code

PerfTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitID tabeli Service

Definicja kolumny UnitID tabeli Service

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServiceTypeID tabeli Service

Definicja kolumny ServiceTypeID tabeli Service

Name

ServiceTypeID

Code

ServiceTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServiceComponentID tabeli Service

Definicja kolumny ServiceComponentID tabeli Service

Name

ServiceComponentID

Code

ServiceComponentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SysFctID tabeli Service

Definicja kolumny SysFctID tabeli Service

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DepartmentID tabeli Service

Definicja kolumny DepartmentID tabeli Service

Name

DepartmentID

Code

DepartmentID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID departamentu


Kolumna InterfaceCd tabeli Service

Definicja kolumny InterfaceCd tabeli Service

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Code tabeli Service

Definicja kolumny Code tabeli Service

Name

Code

Code

Code

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna Description tabeli Service

Definicja kolumny Description tabeli Service

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna StartDT tabeli Service

Definicja kolumny StartDT tabeli Service

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Service

Definicja kolumny StopDT tabeli Service

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Independent tabeli Service

Definicja kolumny Independent tabeli Service

Name

Independent

Code

Independent

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli Service

Definicja kolumny Comments tabeli Service

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna IsExternal tabeli Service

Definicja kolumny IsExternal tabeli Service

Name

IsExternal

Code

IsExternal

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Active tabeli Service

Definicja kolumny Active tabeli Service

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Mnemonic tabeli Service

Definicja kolumny Mnemonic tabeli Service

Name

Mnemonic

Code

Mnemonic

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Recursive tabeli Service

Definicja kolumny Recursive tabeli Service

Name

Recursive

Code

Recursive

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Duration tabeli Service

Definicja kolumny Duration tabeli Service

Name

Duration

Code

Duration

Data Type

DATE

Mandatory

No

Comment

 


Kolumna IsProfile tabeli Service

Definicja kolumny IsProfile tabeli Service

Name

IsProfile

Code

IsProfile

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AccountServID tabeli Service

Definicja kolumny AccountServID tabeli Service

Name

AccountServID

Code

AccountServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsAccounting tabeli Service

Definicja kolumny IsAccounting tabeli Service

Name

IsAccounting

Code

IsAccounting

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NotMedical tabeli Service

Definicja kolumny NotMedical tabeli Service

Name

NotMedical

Code

NotMedical

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna OPK tabeli Service

Definicja kolumny OPK tabeli Service

Name

OPK

Code

OPK

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna PKWiU tabeli Service

Definicja kolumny PKWiU tabeli Service

Name

PKWiU

Code

PKWiU

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer PKWiU


Kolumna ShortName tabeli Service

Definicja kolumny ShortName tabeli Service

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Service

Definicja kolumny FullName tabeli Service

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna OPK2 tabeli Service

Definicja kolumny OPK2 tabeli Service

Name

OPK2

Code

OPK2

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Identyfikator OPK grupuje uslugi na potrzeby kosztów i kontrolingu.
W Systemie wykorzystywany jest przy generowaniu niektórych raportów w module
Recepcja.


Kolumna NotForPatient tabeli Service

Definicja kolumny NotForPatient tabeli Service

Name

NotForPatient

Code

NotForPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

Informacja czy dana usluga zlecana jest w kontekscie pacjenta (pobytu, zdarzenia szpitalnego), czy jest zleceniem
przedmiotowym (badania czystosciowe, wymiana zarówki itp.)


Kolumna ReferralMandatory tabeli Service

Definicja kolumny ReferralMandatory tabeli Service

Name

ReferralMandatory

Code

ReferralMandatory

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga sterujaca wymagalnoscia skierowania do uslugi


Kolumna InsertingPerson tabeli Service

Definicja kolumny InsertingPerson tabeli Service

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli Service

Definicja kolumny InsertDate tabeli Service

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LastModifiedPerson tabeli Service

Definicja kolumny LastModifiedPerson tabeli Service

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Kolumna LastModifiedDT tabeli Service

Definicja kolumny LastModifiedDT tabeli Service

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna IsPackage tabeli Service

Definicja kolumny IsPackage tabeli Service

Name

IsPackage

Code

IsPackage

Data Type

NUMBER(5)

Mandatory

No

Comment

Oznaczenie pakietu uslug


Lista kluczy tabeli Service

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Service

Definicja klucza Identifier_1 tabeli Service

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment